alter proc DropAllTables
as
declare DropAllTableCursor cursor
for
	SELECT name FROM SYSOBJECTS WHERE type='U' and name not like '%sys%'
open DropAllTableCursor
declare @tableName nvarchar(400)
fetch next from DropAllTableCursor into @tableName
while(@@FETCH_STATUS=0)
begin
	exec('drop table '+@tableName);
	fetch next from DropAllTableCursor into @tableName
	print @tableName
end
close DropAllTableCursor
deallocate DropAllTableCursor







	

